Time of day function rule examples

Time of day functions are used with time of day variables to set the time of day and to extract the second/minute/hour from a time of day.

Be sure to use the exact syntax for these functions including spacing and parentheses as specified below.

Function	Example rule	Inputs	Outputs	Further information
TimeOfDay	the latest submission time = TimeOfDay("12:30:00")	12:30:00	the latest submission time = 12:30:00	Get the time of day from a text string
ExtractSecond	the second component of the submission time = ExtractSecond(the submission time)	the submission time: 14:42:32	the second component of the submission time = 32	Get the second component of an input time
ExtractMinute	the minute component of the submission time = ExtractSecond(the submission time)	the submission time: 14:42:32	the minute component of the submission time = 42	Get the minute component of an input time
ExtractHour	the hour component of the submission time = ExtractHour(the submission time)	the submission time: 14:42:32	the hour component of the submission time = 14	Get the hour component of an input time

TIP: The localized syntax for these functions may be viewed:

by clicking here for US English and other languages; or
at Help | Function Reference in Oracle Policy Modeling, in the rule language set for the rulebase project.